﻿/*CREATE TABLE [dbo].[Hansards] (
    [Id]                     INT            IDENTITY (1, 1) NOT NULL,
    [TranscriptXMLLink]      NVARCHAR (MAX) NOT NULL,
    [PublicationStatus]      NVARCHAR (MAX) NOT NULL,
    [Date]                   DATETIME       NOT NULL,
    [Fragment]               INT            NOT NULL,
    [Title]                  NVARCHAR (MAX) NOT NULL,
    [IndexedContent]         NVARCHAR (MAX) NOT NULL,
    [TranscriptPDFLink]      NVARCHAR (MAX) NOT NULL,
    [FullTranscriptXMLLink]  NVARCHAR (MAX) NOT NULL,
    [Context]                NVARCHAR (MAX) NOT NULL,
    [TOCXML]                 NVARCHAR (MAX) NOT NULL,
    [Chamber_Id]             INT            NULL,
    [GenericSearchResult_Id] INT            NOT NULL,
    [Inquiry_Id]             INT            NULL,
    [Parliament_Id]          INT            NOT NULL,
    [CalendarItem_Id]        INT            NOT NULL
);*/



























